MERGE JOIN
Short Description
Operation accepting two sets of rows, each sorted by a value, combining each row from one set with the matching rows from the other, and returning the result.
Detailed Description​
Merge Joins are very common join method taking two pre-sorted sources and for each row in the first set combining matching data from the second set and feeding the output to the next step in the plan.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.